<!doctype html>
<html>
<head>
<meta charset="utf-8">

<link href="../css/einterview.css" rel='stylesheet' type='text/css'>
<link href="../jQueryAssets/jquery.ui.core.min.css" rel="stylesheet" type="text/css">
<link href="../jQueryAssets/jquery.ui.theme.min.css" rel="stylesheet" type="text/css">
<link href="../jQueryAssets/jquery.ui.datepicker.min.css" rel="stylesheet" type="text/css">
<script type="text/javascript" src="http://code.jquery.com/jquery-1.4.1.min.js"></script>
<script type="text/javascript" src="../tinymce/js/tinymce/tinymce.min.js"></script>
<script src="../jQueryAssets/jquery-1.8.3.min.js" type="text/javascript"></script>
<script src="../jQueryAssets/jquery-ui-1.9.2.datepicker.custom.min.js" type="text/javascript"></script>
<link type='text/css' href='css/demo.css' rel='stylesheet' media='screen' />
<link type='text/css' href='css/osx.css' rel='stylesheet' media='screen' />
<script type="text/javascript" src="TimePicker/jquery.timepicker.js"></script>
<link rel="stylesheet" type="text/css" href="TimePicker/jquery.timepicker.css" />
<script type="text/javascript" src="TimePicker/lib/site.js"></script>
<script type="text/javascript">
tinymce.init({
    selector: "textarea"
 });
</script>
<?php

include('../php/db.php');

$db = new mysqli('localhost',$usercon,$passcon,'flss');

if ($_SESSION['login'] == NULL)
{
 header("Location: ../index.php");	
} 
else
{
$login = $_SESSION['login'];

$userid = mysql_query("SELECT * FROM `flss`.`accounts` WHERE `user` = '$login'");
while($rowshow = mysql_fetch_array($userid))
{
	$getid = $rowshow['account_id'];
}


$for_interview = mysql_query("SELECT * FROM applicant_interview_date aid
			 LEFT JOIN applicant a ON aid.applicant_id = a.applicant_id
			 LEFT JOIN job_order jo ON jo.job_id = aid.job_id
			 LEFT JOIN employer e ON e.employer_id = jo.employer_id 
			 WHERE e.employer_id = '$getid'");
}
?>
<title>
Interview Schedule
</title>
</head>
<body style="background-color: white;">

<?php
 include __DIR__ . "/../php/header.php";
?>
<br>
<br>
<br>
<style>
.font{
   font-family: 'Gadugi';
}
.title{
  font-family: 'Gadugi';
  text-align:center;
  padding-top:60px;
  background-color: rgb(250,250,250);
  border-bottom:1px solid #CCCCCC;
  width:100%;
  height:130px
}
</style>
<div class="title"><font size=6><b>Interview Schedule</div></font></b>
            
						<table style="padding-left:150px; padding-right:150px; padding-top:10px;">
					   <?php while($row = mysql_fetch_array($for_interview)){ ?> 

                        <tr class="font">
                          <td width="40%;" style="padding-left:200px;"><b>Event: &nbsp; &nbsp;</b></td>
                          <td style="padding-left:30px;"> You have set an interview with <?=$row['fname'].' '.$row['lname']?></td>
                        </tr>
                        <tr class="font">
                          <td style="padding-left:200px;"><b>Date: &nbsp; &nbsp;</b></td>
                          <td style="padding-left:30px;"><?php $date = new DateTime($row['interview_date'],new DateTimeZone('Asia/Hong_Kong')); echo $date->format('F d, Y');?></td>
                        </tr>
                        <tr class="font">
                          <td style="padding-left:200px;"><b>Time: &nbsp; &nbsp;</b></td>
                          <td style="padding-left:30px;"><?=$row['time_from']?> - <?=$row['time_to']?></td>
                        </tr>
                        <tr class="font">
                          <td style="padding-left:200px;"><b>Where: &nbsp; &nbsp;</b></td>
                          <td style="padding-left:30px;">nearest location: <?=$row['nearest_location']?></td>
                        </tr>
                        <tr class="font">
                        <td style="padding-left:200px;"><b>Job Title: &nbsp; &nbsp;</b></td>
                        <td style="padding-left:30px;"><?=$row['Title']?></td>
                        </tr>
                        <tr>
                        <td width="5%;">
                        <hr style="border-top:dotted 1px;">
                        </td>
                        <td width="5px;">
                        <hr style="border-top:dotted 1px;">
                        </td>
                        </tr>
                       <?php } ?>
            
                    </table>
<?php
 include __DIR__ . "/../php/footer.php";

?>
</body>
</html>